Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #5555: ALTER TABLE ONLY ... SET NOT NULL on parent prevent prior inherited tables from being restored - Mailing list pgsql-bugs

From Bernd Helmle
Subject Re: BUG #5555: ALTER TABLE ONLY ... SET NOT NULL on parent prevent prior inherited tables from being restored
Date
Msg-id 2F9B408D3BA1FDCB0664C3EC@[172.26.14.62]
Whole thread Raw
In response to Re: BUG #5555: ALTER TABLE ONLY ... SET NOT NULL on parent prevent prior inherited tables from being restored  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
--On 12. Juli 2010 14:39:19 -0400 Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Yeah.  Past discussions of this have leaned to the viewpoint that we
> should disallow the above, ie it should not be possible to have NOT NULL
> on the parent unless all the children have it too.  Nobody's got round
> to implementing it though.  There's a TODO item for it: see
>     "Move NOT NULL constraint information to pg_constraint"


FYI, i'm currently working on it, see

<https://commitfest.postgresql.org/action/patch_view?id=312>


        Bernd

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #5559: Full SSL verification fails when hostaddr provided
Next
From: Stephen Frost
Date:
Subject: Re: BUG #5559: Full SSL verification fails when hostaddr provided